24. OLAP Cubes: Slice and Dice

L01-04-Part 3 OLAP Cubes- Slice And Dice

OLAP

QUIZ QUESTION::

Match the OLAP operation to the correct definition.

ANSWER CHOICES:



Definition

Operation

Reducing N dimensions to N-1 dimensions by restricting one dimension to a single value.

Same dimensions but computing a sub-cube by restricting, some of the values of the dimensions.

Aggregates or combines values and reduces number of rows or columns.

Decomposes values and increases number of rows or columns.

SOLUTION:

Definition

Operation

Aggregates or combines values and reduces number of rows or columns.

Reducing N dimensions to N-1 dimensions by restricting one dimension to a single value.

Decomposes values and increases number of rows or columns.

Same dimensions but computing a sub-cube by restricting, some of the values of the dimensions.